The following steps demonstrate how to port the master device to a different disk. While executing this task, please refer to SYBASE's related documentation Technical Documents #1324 entitled "Segment Remapping with Load database When Moving a Database ").
Note that you must stop SQL Server applications before executing buildmaster.
The key to success is that the contents of each row in the new sysusages system table are consistent with those in the o
Email publisher Email From = "Buildmaster@mycompany.com" Mailhost = "Smtp.mycompany.com" Includedetails = "True" > Users > User Name = "Buildguru" Group = "Buildmaster" Address = "Buildguru@mycompany.com" /> User Name = "Joedeveloper" Group = "Developers" Address = "Joedeveloper@thoughtworks.com" /> Users > Groups > Group Name = "Developers" Not
device that is large enough
$buildmaster-D-ssize (size is 2K)
Example: $buildmaster-d/sybase/database/master.dat-s102400
3) Modify Run_servername file
Edit the Run_server_name file, and the-D argument points to the newly created device name.
4 Single user mode restart server
$startserver-F Run_servername-m
5) Execute Installmaster script
6 load master database from backup file
1>load database Mast
File to start the database.
Dump tran master with truncate_onlyu
Go
1) back up the master database
Dump database master to 'backup path and file name'
2) Stop the sybase Service
Shutdown
3) edit the sybase Service Startup File (generally RUN _ service name in unix, and RUN _ service name in windows. bat ). Add-T3607 to the command line of the Startup File)
4) use the Startup File to start the service, and then dump tran master with truncate_only
5) at this time, the dump usually clears many log
Server1>shutdown2>go2. Create a new master device that is large enough$buildmaster-dExample: $buildmaster-d/sybase/data/master.dat-s1024003. Modify the Run_servername fileEdit the Run_server_name file, and the-D argument points to the newly created device name.4. Single User mode restart server$startserver-F Run_servername-m5. Execute Installmaster Script6. Load master database from backup files1>load data
to write this log. Sends a message to errorlog for each pending transaction; then executes the sp_thresholdactionSp_thresholdaction users to write their ownCREATE PROCEDURE Sp_thresholdaction@dbname varchar (30),@segmentname varchar (30),AsDump transaction @dbname to "DEVICE"Print "LOG DUMP:%1! For%2! Dumped ", @segmentname, @dbnameWhere parameters:@dbname the name of the database to reach the threshold;@segmentname is the name of the segment to reach the valve value;
Handling of corrupted use
master device that is large enough
$buildmaster-D-ssize (size is 2K)
Example: $buildmaster-d/sybase/database/master.dat-s102400
3) Modify Run_servername file
Edit the Run_server_name file, and the-D argument points to the newly created device name.
4 Single user mode restart server
$startserver-F Run_servername-m
5) Execute Installmaster script
6 load master database from backup file
1>load databa
ASE can ' t setup and has no valid dump of Master
1. Edit Run_servernameAt the command line last add:-t3607
2. Single user mode start ASE$CD Install$startserver-F Run_servername-m
3. BCP out system table$BCP Master. sysdevices Out/directory.spec/devs-usa-p-C$BCP Master. sysdatabases Out/directory.spec/dbs-usa-p-C$BCP Master. sysusages Out/directory.spec/usages-usa-p-C$BCP Master. syslogins Out/directory.spec/logins-usa-p-C$BCP Master. Sysconfigures Out/directory.spec/configures-usa-p-C$BCP Ma
other plugins you want, you just need to use these names to re-register the new plugins, the registered plugins will be overwritten by default.
Plug-in pre-configuration/default value:
When registering plugins, you can specify the default value for some attributes of plugin or nested plugin. Simple use of attributes or child elements to define the default value. The default value of plugin can also be overwritten during actual use in the project. Note: When nested elements have a multipl
Maintain consistency with the content created when buildbot create-master is used to analyze key points
For more details, please read the manual on the official website.
Http://buildbot.net/repos/release/docs/buildbot.htmlJimi @ Debian :~ /Buildbot/Master $ cat master. cfg
#-*-Python -*-# Ex: Set syntax = Python: # Set the VI highlight ModeC = buildmasterconfig = {}
From buildbot. buildslave import buildslaveC ['slafs'] = [buildslave ("bot1name", "bot1passwd")] # name and password required to c
. Notify the corresponding owner of the integrated result by email or jabber.
Based on the above requirements, the project compilation script uses Maven, the version management tool uses CVs, and the continuous integration tool uses cc. Assuming that the maven-based project compilation script has been compiled, the cruisecontrol script is written as follows:Projectfile = demo/Project. xmlGoal = Demo: build/>Returnaddress = buildmaster@yourdomain.comS
The following steps explain how to migrate a master device to a different disk. While performing this task, please refer to Sybase's related documentation (technical documents#1324 entitled "Segment remapping with Load database when moving a database" )。 Note that you want to stop the application of SQL Server before executing buildmaster.
The key to success is that each row of the new sysusages system table matches the contents of the Old sysusages s
Contact Us
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.